a) DDL (Data Definition Language)
b) DML (Data Manipulation Language)
c) DCL (Data Control Language)
d) TCL (Transaction Control Language)
--------------------------------------
Common Terms :
-----------
Tuples :- Row of Table
Attributes :- Column Name
Entity :- Table Name
Schema :- Structure of Database(table+column)
---------------------------------------------
::DDL::(PERFORM ROLE ON SCHEMA)
CREATE , DROP, ALTER, TRUNCATE, RENAME

::DML:: (ACTION ON TUPLES)
SELECT, UPDATE, INSERT, DELETE

::DCL:: (PRIVILEDGE(permision of user))
GRANT , REVOKE

::TCL:: (Transactions)
BEGIN, START, COMMIT, SAVEPOINT, ROLLBACK
---------------------------------------------
Q) DELETE VS TRUNCATE(empty)

TRUNCATE PROCESS:
a) Take the tmp backup of Database table
b) DROP that table
c) Recreate that table with Step (a)
   TRUNCATE = DROP+CREATE
---------------------------------------------
|----
|~  |
|`_ |

(`) is Backtick
================
Backtick is used to show
a) Column Name
b) Table Name
c) Database Name
---------------------------------------------
NOTE : Values enclosed with Single Quotes(')
---------------------------------------------
NOTE :
a) Table Name Must be Plural for example
    user (X)
    users (OK)
    categoty (X)
    categories (OK)
    country (X)
    countries (OK)
b) if table name is combination of more then
   one word then it must be separated with
   underscore.
   ex:
      suite_users (OK)
      suiteusers ( :( )
      suiteUsers ( :( )

c) don't use UPPERCASE in table name/DB Name/COl Name.

d) First Column Of any table must be
   `id` INT AUTO_INCREMENT PRIMARY KEY

e) If Table is realated with any kind of
   registeration then make some extra fields

   `created_date` DATETIME
   `modified_date` TIMESTAMP
   `status` ENUM('0','1')

f) Use ALL Keywords in UPPERCASE.





























